<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="http://www.springframework.org/tags" prefix="spring"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="sf"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
<script type="text/javascript" src="../js/global.js"></script>
<script type="text/javascript"
	src="../js/jquery-easyui-1.4.3/datagrid-export.js"></script>
<script type="text/javascript">
	function formattersex(value, row, index) {
		return value == 1 ? "男" : "女";
	}

	function formatterstate(value, row, index) {
		return value == 1 ? "状态无" : "状态有";
	}

	function formatterisValid(value, row, index) {
		return value == 1 ? "有效" : "无效";
	}

	function formatterisReturnVist(value, row, index) {
		return value == 1 ? "已回访" : "未回访";
	}

	function formatterisHome(value, row, index) {
		return value == 1 ? "已上门" : "未上门";
	}

	function formatterisPay(value, row, index) {
		return value == 1 ? "已缴费" : "未缴费";
	}

	function formatterisReturnMoney(value, row, index) {
		return value == 1 ? "已退费" : "未退费";
	}

	function formatterisInClass(value, row, index) {
		return value == 1 ? "已进班" : "未进班";
	}

	function formatterisDel(value, row, index) {
		return value == 1 ? "已删除" : "未删除";
	}

	function formatterisBaoBei(value, row, index) {
		return value == 1 ? "已报备" : "未报备";
	}

	$(function() {
		initStu();
	})

	function initStu() {
		$("#tabStu").datagrid({
			url : "getStu",
			method : "post",
			fitColumns : true,
			toolbar : "#tabBar",
			pagination : true,
			queryParams : {
				name : $("#name").val(),
				phone : $("#phone").val(),
				ziXunName : $("#ziXunName").val(),
				isPay : $("#isPay").combobox("getValue"),
				isValid : $("#isValid").combobox("getValue"),
				isReturnVist : $("#isReturnVist").combobox("getValue"),
				qq : $("#qq").val(),
				createTime : $("#createTime").datebox('getValue'),
				homeTime : $("#homeTime").datebox('getValue'),
				firstVistTime : $("#firstVistTime").datebox('getValue'),
				payTime : $("#payTime").datebox('getValue'),
				inClassTime : $("#inClassTime").datebox('getValue'),
			}

		})
	}
	
	//自定义验证
    $.extend($.fn.validatebox.defaults.rules, {
    phoneRex:{
        validator: function(value){
        var rex=/^1[3-8]+\d{9}$/;
        var rex2=/^((0\d{2,3})-)(\d{7,8})(-(\d{3,}))?$/;
        if(rex.test(value)||rex2.test(value))
        {
          return true;
        }else
        {
           return false;
        }
        },
        message: '请输入正确电话或手机格式'
    },
    qq: {// 验证QQ
        validator: function (value) {
            return /^[1-9]\d{4,9}$/i.test(value);
        },
        message: 'QQ号码格式不正确'
    },
    age: {// 验证年龄
        validator: function (value) {
            return /^(?:[1-9][0-9]?|1[01][0-9]|120)$/i.test(value);
        },
        message: '年龄必须是0到120之间的整数'
    }
});	
	
	
	/* 新建学员窗口 */
	function addStu() {
		$("#add-dialog").dialog("open");
	}
	/* 学员窗口取消 */
	function clearStu() {
		$("#add-dialog").dialog("close");
	}
	/* 保存新建学员 */
	function bcStu() {
		$.post("addStu", {
			/* usersId : $("#addusersId").val(), */
			name : $("#addname").val(),
			sex : $("#addsex").combobox("getValue"),
			age : $("#addage").val(),
			phone : $("#addphone").val(),
			status : $("#addstatus").val(),
			state : $("#addstate").combobox("getValue"),
			msgSource : $("#addly").val(),
			sourceUrl : $("#addwz").val(),
			sourceKeyWorld : $("#addgj").val(),
			qq : $("#addqq").val(),
			weixin : $("#addwx").val(),
			isBaoBei : $("#addisBaoBei").combobox("getValue"),
			content : $("#addbz").val()
		}, function(res) {
			if (res > 0) {
				$("#tabStu").datagrid("reload");
				$("#add-dialog").dialog("close");
				$.messager.alert("提示", "新增成功")
			} else {
				$.messager.alert("提示", "新增失败")
			}
		}, "json")
	}

	function formattercaozuo(value, row, index) {
		return "<a href='javascript:void(0)' onclick='edit(" + index
				+ ")'>编辑</a>   <a href='javascript:void(0)' onclick='chakan("
				+ index
				+ ")'>查看</a>  <a href='javascript:void(0)' onclick='genzong("
				+ index + ")'>跟踪</a>  <a href='javascript:void(0)' onclick='upYouXiao("
				+ index + ")'>失效</a> <a href='javascript:void(0)' onclick='upShiXiao("
				+ index + ")'>恢复有效</a>";
	}
	

	function upShiXiao(index) {

		var datas = $("#tabStu").datagrid("getData");
		var row = datas.rows[index];
		if (row.isValid == 2) {
			$.messager.confirm('确认失效', '您确认想要恢复' + row.name + '学生吗？', function(r) {
				if (r) {
					$.post("upvaild", {
						id : row.id
					}, function(res) {
						if (res > 0) {
							$('#tabStu').datagrid('reload');
							$.messager.alert('提示', '恢复成功！！！');
						}
					}, "json")
				}
			});
		} else {
			$.messager.alert('提示', '该学生处于有效状态！！！');
		}

	}


	/* 跟踪 */
	function genzong(index) {
		var arr = $("#tabStu").datagrid("getData");
		var row = arr.rows[index];
		 if(row.isValid==1){
				$("#genzongDialog").dialog("open");
				$("#genzong-frms").form("load", row);
				alert(row.id)
				alert(row.usersId)
				$("#GZid").numberbox("setValue", row.id);
				$("#GZusersId").numberbox("setValue", row.usersId); 
				$("#genzongDialog").window("setTitle", "正在对" + row.name + "添加跟踪");
				/* $("#name12").textbox("setValue", row.name); */
			 
		 }else{
			 $.messager.alert('提示', '已失效不能进行跟踪！！！');
		 }
	}
	/* 提交跟踪 */
	function follerSubmit() {
		alert($("#GZid").val())
		$.post("getgenzong", {
			studentId : $("#GZid").val(),
			userId : $("#GZusersId").val(),  
			/* name : $("#name").val(), */
			followType : $("#followType").combobox("getValue"),
			content : $("#content").val(),
			followTime : $("#followTime").val(),
			followState : $("#followState").combobox("getValue")

		}, function(res) {
			if (res > 0) {
				/* $("#tabStu").datagrid("reload");  */
				$("#genzongDialog").dialog("close");
				$.messager.alert("提示", "跟踪成功")
			} else {
				$.messager.alert("提示", "跟踪失败")
			}
		}, "json")
	}

	/* 关闭跟踪 */
	function follerClose() {
		$("#genzongDialog").dialog("close");
	}
	function chakan(index) {
		var data = $("#tabStu").datagrid("getData");
		var row = data.rows[index];
		$("#chakan-frm").form("load", row);
		$("#chakan-dialog").dialog("open");
	}

	function closeStu() {
		$("#chakan-dialog").dialog("close");
	}

	function edit(index) {
		var data = $("#tabStu").datagrid("getData");
		var row = data.rows[index];
		$("#edit-frm").form("load", row);
		$("#edit-dialog").dialog("open");
	}

	function updateStu() {
		$.post("updateStu", {
			id : $("#updateid").val(),
			name : $("#updatename").val(),
			sex : $("#updatesex").combobox("getValue"),
			age : $("#updateage").val(),
			phone : $("#updatephone").val(),
			status : $("#updatestatus").val(),
			state : $("#updatestate").combobox("getValue"),
			msgSource : $("#updatemsgSource").val(),
			sourceUrl : $("#updatesourceUrl").val(),
			sourceKeyWorld : $("#updatesourceKeyWorld").val(),
			address : $("#updateaddress").val(),
			qq : $("#updateqq").val(),
			weixin : $("#updateweixin").val(),
			learnForward : $("#updatelearnForward").val(),
			isBaoBei : $("#updateisBaoBei").combobox("getValue"),
			ziXunName : $("#updateziXunName").val(),
			createUser : $("#updatecreateUser").val(),
			concern : $("#updateconcern").val()
		}, function(res) {
			if (res > 0) {
				$("#tabStu").datagrid("reload");
				$("#edit-dialog").dialog("close");
				$.messager.alert("提示", "修改成功")
			} else {
				$.messager.alert("提示", "修改失败")
			}
		}, "json")
	}

	function updateClear() {
		$("#edit-dialog").dialog("close");
	}

	/* //导出excel
	function exportExcel() {
		$('#tabStu').datagrid('toExcel', 'gsy.xls'); // export to excel
	} */

	
	
	
	
	
	
	
	
	
	
	
	
	//打开设置隐藏列对话框
	function lookstu() {
		$("#hiddenColumn_dialog").dialog("open");
	}
	function saveColumn() {
		var cbx = $("#hiddenColumn_form input[type='checkbox']"); //获取Form里面是checkbox的Object
		var checkedValue = "";
		var unCheckValue = "";
		for (var i = 0; i < cbx.length; i++) {
			if (cbx[i].checked) {//获取已经checked的Object
				if (checkedValue.length > 0) {
					checkedValue += "," + cbx[i].value; //获取已经checked的value

				} else {
					checkedValue = cbx[i].value;
				}
			}
			if (!cbx[i].checked) {//获取没有checked的Object
				if (unCheckValue.length > 0) {
					unCheckValue += "," + cbx[i].value; //获取没有checked的value

				} else {
					unCheckValue = cbx[i].value;
				}
			}
		}
		var checkeds = new Array();
		if (checkedValue != null && checkedValue != "") {
			checkeds = checkedValue.split(',');
			for (var i = 0; i < checkeds.length; i++) {
				$('#tabStu').datagrid('hideColumn', checkeds[i]); //隐藏相应的列
			}

		}
		var unChecks = new Array();

		if (unCheckValue != null && unCheckValue != "") {
			unChecks = unCheckValue.split(',');
			for (var i = 0; i < unChecks.length; i++) {
				$('#tabStu').datagrid('showColumn', unChecks[i]); //显示相应的列
			}
		}
		$('#hiddenColumn_dialog').dialog('close');
	}
	//关闭设置隐藏列弹框
	function closed_hiddenColumn() {
		$('#hiddenColumn_dialog').dialog('close');
	}
	//全选按钮
	function ChooseAll() {

		var a = $("#isQuanXuan").text();//获取按钮的值
		if ("全选" == a.trim()) {
			$("#hiddenColumn_form input[type='checkbox']")
					.prop("checked", true);//全选
			$('#isQuanXuan').linkbutton({
				text : '全不选'
			});
		} else {
			$("#hiddenColumn_form input[type='checkbox']").removeAttr(
					"checked", "checked");//取消全选
			$('#isQuanXuan').linkbutton({
				text : '全选'
			});
		}

	}
	
	function formatterusers(value, row, index){
		if(value!=null){
			return value.loginName;
		}
		
	}
	
	
	/* 修改是否有效 */
	function upYouXiao(index) {
		
		
		var datas = $("#tabStu").datagrid("getData");
		var row = datas.rows[index];
		if(row.isValid==1){
			$.messager.confirm('确认失效', '您确认想要失效'+row.name+'学生吗？', function(r) {
				if (r) {
					$.post("upIsvaild", {
						id : row.id
					}, function(res) {
						if (res > 0) {
							$('#tabStu').datagrid('reload');
							$.messager.alert('提示', '失效成功！！！');
						}
					}, "json")
				}
			});
		}else{
			$.messager.alert('提示', '不能进行二次失效！！！');
		}
		
			
		} 
			
	
		
	
	

	//导出Excel表
	function exportExcel(){
		var rows = $("#tabStu").datagrid("getSelections");
		if (rows.length == 0) {
			$.messager.alert("系统信息", "请选择导出的数据");
			return;
		}
		$("#win-daochu").window("open");
	}

	function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) {
		//如果jsondata不是对象，那么json.parse将分析对象中的json字符串。
		var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData)
				: JSONData;
		var CSV = '';
		//在第一行拼接标题
		CSV += ReportTitle + '\r\n\n';
		//产生数据标头
		if (ShowLabel) {
			var row = "";
			//此循环将从数组的第一个索引中提取标签
			for ( var index in arrData[0]) {
				//现在将每个值转换为字符串和逗号分隔
				row += index + ',';
			}
			row = row.slice(0, -1);
			//添加带换行符的标签行
			CSV += row + '\r\n';
		}
		//第一个循环是提取每一行
		for (var i = 0; i < arrData.length; i++) {
			var row = "";
			//第二个循环将提取每个列并将其转换为以逗号分隔的字符串
			for ( var index in arrData[i]) {
				row += '"' + arrData[i][index] + '",';
			}
			row.slice(0, row.length - 1);
			//每行后添加换行符
			CSV += row + '\r\n';
		}

		if (CSV == '') {
			alert("Invalid data");
			return;
		}

		var uri = 'data:text/csv;charset=utf-8,\ufeff' + encodeURI(CSV);
		var link = document.createElement("a");
		link.href = uri;
		link.style = "visibility:hidden";
		link.download = ReportTitle + ".csv";
		document.body.appendChild(link);
		link.click();
		document.body.removeChild(link);
	}

	function bgdaochu() {
		alert(2)
		var rows = $("#tabStu").datagrid("getSelections");
		var ches = $("#daochu-checkbox :checkbox");//要导出显示的列
		var datarows = [];//空数组
		var row = {};//空json对象
		for (var i = 0; i < rows.length; i++) {
			for (var k = 0; k < ches.length; k++) {
				var na = ches[k].name;//name:字段名
				var isOk = ches[k].checked;
				if(isOk && na == "name"){row.姓名 = rows[i].name;}
				if(isOk && na == "sex"){row.性别 = rows[i].sex.value==1? "男":"女";}
				if(isOk && na == "age"){row.年龄 = rows[i].age}
				if(isOk && na == "phone"){row.电话 = rows[i].phone;}
				if(isOk && na == "status"){row.学历 = rows[i].status;}
				if(isOk && na == "state"){row.状态 = rows[i].state.value == 1 ? "状态无" : "状态有";}
				
				if(isOk && na == "dafen"){row.打分 = rows[i].dafen;}
				if(isOk && na == "msgSource"){row.来源渠道 = rows[i].msgSource;}
				if(isOk && na == "sourceUrl"){row.来源网站 = rows[i].sourceUrl;}
				if(isOk && na == "sourceKeyWorld"){row.来源关键词= rows[i].sourceKeyWorld;}
				
				if(isOk && na == "address"){row.地址 = rows[i].address;}
				if(isOk && na == "netPusherId"){row.推销者id = rows[i].netPusherId;}
				if(isOk && na == "askerId"){row.发布者id = rows[i].askerId;}
				if(isOk && na == "qq"){row.QQ = rows[i].qq;}
				if(isOk && na == "weixin"){row.微信 = rows[i].weixin;}
				if(isOk && na == "content"){row.内容 = rows[i].content;}
			 	if(isOk && na == "createTime"){row.创建时间 = rows[i].createTime;} 
				if(isOk && na == "learnForward"){row.来源部门 = rows[i].learnForward;}
				if(isOk && na == "record"){row.课程方向 = rows[i].record;}
				
				if(isOk && na == "firstVistTime"){row.第一次回访时间 = rows[i].firstVistTime;}
				if(isOk && na == "isHome"){row.是否上门 = rows[i].isHome.value == 1 ? "已上门" : "未上门";}
				if(isOk && na == "homeTime"){row.上门时间 = rows[i].homeTime;}
				if(isOk && na == "lostValid"){row.无效原因 = rows[i].lostValid;}
				if(isOk && na == "payTime"){row.缴费时间= rows[i].payTime;}
				if(isOk && na == "money"){row.金额 = rows[i].money;}
				if(isOk && na == "isReturnMoney"){row.是否退费= rows[i].isReturnMoney.value == 1 ? "已退费" : "未退费";}
				if(isOk && na == "isInClass"){row.是否进班 = rows[i].isInClass.value == 1 ? "已进班" : "未进班";}
				if(isOk && na == "inClassTime"){row.进班时间 = rows[i].inClassTime;}
				if(isOk && na == "inClassContent"){row.进班备注 = rows[i].isclasscontentinClassContent;}
				if(isOk && na == "askerContent"){row.退费原因 = rows[i].askerContent;}
				if(isOk && na == "isDel"){row.是否删除 = rows[i].isDel. value == 1 ? "已删除" : "未删除";}
				if(isOk && na == "formPart"){row.来源部门 = rows[i].formPart;}
				if(isOk && na == "concern"){row.学员关注= rows[i].concern;}
				if(isOk && na == "isBaoBei"){row.是否报备 = rows[i].isBaoBei.value == 1 ? "已报备" : "未报备";}
				if(isOk && na == "ziXunName"){row.录入人= rows[i].users.loginName;}
				if(isOk && na == "returnMoneyReason"){row.退费原因 = rows[i].returnMoneyReason;}
				if(isOk && na == "preMoney"){row.定金金额 = rows[i].preMoney;}
				if(isOk && na == "preMoneyTime"){row.定金时间 = rows[i].preMoneyTime;}
				if(isOk && na == "isPay"){row.是否缴费 = rows[i].isPay.value == 1 ? "已缴费" : "未缴费";}
				if(isOk && na == "isValid"){row.是否有效 = rows[i].value == 1 ? "有效" : "无效";}
				if(isOk && na == "isReturnVist"){row.是否回访 = rows[i].isReturnVist.value == 1 ? "已回访" : "未回访";}
				
			}
			datarows[i] = row;
			row = {};
		}
		var data = JSON.stringify(datarows);//转换数据为json
		var title = $("#daochu-title").textbox("getValue");//获取标题
		alert(title);
		if(title!=null && title!=''){
			JSONToCSVConvertor(data, title , true);
			$("#win-daochu").window("close");
		}else{
			$.messager.alert("系统信息", "请填写Excel标题");
		}
	}
	
	
	
	
	
</script>
</head>
<body>
   <!-- <a href="javascript:void(0)" onclick="a()"></a> -->
	<table id="tabStu" class="easyui-datagrid">
		<thead>
			<tr>

				<!--Name：学生名字    record:课程方向		lostValid:无效原因		createTime:创建时间
		isHome:是否上门	homeTime:上门时间		money:定金金额		preMoneyTime:定金时间
		ispay:是否缴费	paymoney:缴费时间 		money:缴费金额	isReturnMoney:是否退费	
		returnMoneyReason:退费原因		isInClass:是否进班	inClassTime:进班时间
		inClassConteent:进班备注	ZiXunName:咨询师备注（跟踪者）	followTime:跟踪时间
		nextFollowTime:下一次跟踪时间
		isReturnVist：是否回访
	  -->
				<th data-options="field:'asd',checkbox:'true'"></th> 
				<!-- <th data-options="field:'ww',checkbox:'复选框'"></th> -->
				<th data-options="field:'id',title:'ID'"></th>
				<th data-options="field:'name',title:'名称'"></th>
				<th data-options="field:'sex',title:'性别',formatter:formattersex"></th>
				<th data-options="field:'age',title:'年龄'"></th>
				<th data-options="field:'users',title:'咨询师名称',formatter:formatterusers,hidden:true"></th>
				<th data-options="field:'phone',title:'电话'"></th>
				<th data-options="field:'status',title:'学历'"></th>
				<th data-options="field:'state',title:'状态',formatter:formatterstate"></th>
				<th data-options="field:'dafen',title:'打分'"></th>
				<th data-options="field:'msgSource',title:'消息来源'"></th>
				<th data-options="field:'sourceUrl',title:'来源网站'"></th>
				<th data-options="field:'sourceKeyWorld',title:'来源关键词'"></th>
				<th data-options="field:'address',title:'地址'"></th>
				<!-- <th data-options="field:'netPusherId',title:'推销者ID'"></th>
				<th data-options="field:'askerId',title:'发布者ID'"></th> -->
				<th data-options="field:'qq',title:'QQ'"></th>

				<th data-options="field:'weixin',title:'消息来源'"></th>
				<th data-options="field:'content',title:'在线备注'"></th>
				<th data-options="field:'createTime',title:'创建时间'"></th>
				<th data-options="field:'learnForward',title:'来源部门'"></th>

				<th data-options="field:'record',title:'课程方向'"></th>


				<th data-options="field:'firstVistTime',title:'首次回访时间'"></th>
				<th
					data-options="field:'isHome',title:'是否上门',formatter:formatterisHome"></th>
				<th data-options="field:'homeTime',title:'上门时间'"></th>
				<th data-options="field:'lostValid',title:'无效原因'"></th>

				<th data-options="field:'payTime',title:'缴费时间'"></th>
				<th data-options="field:'money',title:'金额（定金/缴费）'"></th>

				<th
					data-options="field:'isReturnMoney',title:'是否退费',formatter:formatterisReturnMoney"></th>
				<th
					data-options="field:'isInClass',title:'是否进班',formatter:formatterisInClass"></th>
				<th data-options="field:'inClassTime',title:'进班时间'"></th>
				<th data-options="field:'inClassContent',title:'进班备注'"></th>
				<th data-options="field:'askerContent',title:'退费原因'"></th>
				<th
					data-options="field:'isDel',title:'是否删除',formatter:formatterisDel"></th>
				<th data-options="field:'formPart',title:'来源部门'"></th>

				<th data-options="field:'concern',title:'学员关注'"></th>
				<th
					data-options="field:'isBaoBei',title:'是否报备',formatter:formatterisBaoBei"></th>
				
				<th data-options="field:'createUser',title:'录入人'"></th>
				<th data-options="field:'returnMoneyReason',title:'退费原因'"></th>
				<th data-options="field:'preMoney',title:'定金金额'"></th>
				<th data-options="field:'preMoneyTime',title:'定金时间'"></th>
				<th
					data-options="field:'isPay',title:'是否缴费',formatter:formatterisPay"></th>
				<th
					data-options="field:'isValid',title:'是否有效',formatter:formatterisValid"></th>
				<th
					data-options="field:'isReturnVist',title:'是否回访',formatter:formatterisReturnVist"></th>
				
				<th
					data-options="field:'formattercaozuo',title:'操作',formatter:formattercaozuo"></th>
			</tr>
		</thead>
	</table>

	<!-- 添加跟踪信息 -->
	<div id="genzongDialog" class="easyui-dialog"
		data-options="modal:true,closed:true">
		<form id="genzong-frms" class="easyui-form" title="跟踪的窗口">
			<table>
				<tr>
					<td><label for="name">id:</label></td>
					<td><input class="easyui-numberbox" type="text" id="GZid"
						name="id" data-options="required:true" /></td>
				</tr>
				
				 <tr>
					<td><label for="name">usersId:</label></td>
					<td><input class="easyui-numberbox" type="text" id="GZusersId"
						name="usersId" data-options="required:true" /></td>
				</tr> 
				
				<!-- <tr>
					<td><label for="name">id:</label></td>
					<td><input class="easyui-numberbox" type="text" id="GZUid"
						name="id" data-options="required:true" /></td>
				</tr> -->
				<!-- <tr>
					<td><label for="name">学生姓名:</label></td>
					<td><input class="easyui-textbox" type="text" id="name12"
						name="name" data-options="required:true" /></td>
				</tr> -->
				<tr>
					<td><label for="name">跟踪方式:</label></td>
					<td><select id="followType" class="easyui-combobox">
							<option value="">---请选择---</option>
							<option value="面谈">面谈</option>
							<option value="跟踪">跟踪</option>
							<option value="网络">网络</option>
					</select></td>
				</tr>


				<tr>
					<td><label for="name">内容:</label></td>
					<td><input class="easyui-validatebox" type="text" id="content"
						data-options="required:true" /></td>
				</tr>
				 <tr>
					<td><label for="name">跟踪时间:</label></td>
					<td><input class="easyui-datebox" type="text"
						id="followTime" data-options="required:true" /></td>
				</tr> 
				<!-- <tr>
					<td><label for="name">回访情况:</label></td>
					<td><input class="easyui-validatebox" type="text"
						id="followState" data-options="required:true" /></td>
				</tr> -->

				<tr>
					<td><label for="name">回访情况:</label></td>
					<td><select id="followState" class="easyui-combobox">
							<option value="">---请选择---</option>
							<option value="已回访">已回访</option>
							<option value="未回访">未回访</option>
					</select></td>
				</tr>


				<tr>
					<td><a href="javascript:void(0)" class="easyui-linkbutton"
						onclick="follerSubmit()">提交</a></td>
					<td><a href="javascript:void(0)" class="easyui-linkbutton"
						onclick="follerClose()">取消</a></td>
				</tr>
			</table>
		</form>

	</div>

	<!-- 设置隐藏列 -->
	<div id="hiddenColumn_dialog" class="easyui-dialog"
		data-options="title:'设置隐藏列',modal:true,closed:'true',
			buttons:[{
				text:'保存',
				handler:function(){
				saveColumn();<!-- 保存 -->
				initStu();<!-- 刷新 -->
				closed_hiddenColumn();<!-- 关闭弹窗 -->
				}
			},{
				text:'关闭',
				handler:function(){
				closed_hiddenColumn();
				}
			}]">
		<form style="width: 450px; height: 300px;" id="hiddenColumn_form"
			class="easyui-form">
			<a href="javascript:void()" class="easyui-linkbutton" id="isQuanXuan"
				onclick="ChooseAll()" data-options="iconCls:'icon-edit'">全选</a>
			<table>
				<tr>
					<td><input type="checkbox" value="id" />编号</td>

					<td><input type="checkbox" value="name" />姓名</td>

					<td><input type="checkbox" value="sex" />性别</td>

					<td><input type="checkbox" value="age" />年龄</td>
				</tr>
				<tr>
					<td><input type="checkbox" value="phone" />电话</td>

					<td><input type="checkbox" value="status" />学历</td>

					<td><input type="checkbox" value="state" />状态</td>

					<td><input type="checkbox" value="dafen" />打分</td>
				</tr>
				<tr>
					<td><input type="checkbox" value="msgSource" />来源渠道</td>

					<td><input type="checkbox" value="sourceUrl" />来源网站</td>

					<td><input type="checkbox" value="sourceKeyWorld" />来源关键词</td>

					<td><input type="checkbox" value="address" />地址</td>
				</tr>
				<tr>
					<!-- <td><input type="checkbox" value="netPusherId" />推销者id</td>

					<td><input type="checkbox" value="askerId" />发布者id</td> -->

					<td><input type="checkbox" value="qq" />QQ</td>

					<td><input type="checkbox" value="weixin" />微信</td>
				</tr>
				<tr>
					<td><input type="checkbox" value="content" />内容</td>

					<td><input type="checkbox" value="createTime" />创建时间</td>

					<td><input type="checkbox" value="learnForward" />来源部门</td>
					<td><input type="checkbox" value="record" />课程方向</td>

				</tr>
				<tr>



					<td><input type="checkbox" value="firstVistTime" />第一次回访时间</td>

					<td><input type="checkbox" value="isHome" />是否上门</td>
					<td><input type="checkbox" value="homeTime" />上门时间</td>

					<td><input type="checkbox" value="lostValid" />无效原因</td>
				</tr>
				<tr>



					<td><input type="checkbox" value="payTime" />缴费时间</td>
					<td><input type="checkbox" value="money" />金额</td>

					<td><input type="checkbox" value="isReturnMoney" />是否退费</td>

					<td><input type="checkbox" value="isInClass" />是否进班</td>
				</tr>
				<tr>


					<td><input type="checkbox" value="inClassTime" />进班时间</td>
					<td><input type="checkbox" value="inClassContent" />进班备注</td>

					<td><input type="checkbox" value="askerContent" />退费原因</td>

					<td><input type="checkbox" value="isDel" />是否删除</td>
				</tr>
				<tr>



					<td><input type="checkbox" value="formPart" />来源部门</td>
					<td><input type="checkbox" value="concern" />学员关注</td>

					<td><input type="checkbox" value="isBaoBei" />是否报备</td>

					<td><input type="checkbox" value="ziXunName" />咨询师姓名</td>
				</tr>
				<tr>


					<td><input type="checkbox" value="createUser" />录入人</td>
					<td><input type="checkbox" value="returnMoneyReason" />退费原因</td>

					<td><input type="checkbox" value="preMoney" />定金金额</td>

					<td><input type="checkbox" value="preMoneyTime" />定金时间</td>
				</tr>
				<tr>

					<td><input type="checkbox" value="isPay" />是否缴费</td>
					<td><input type="checkbox" value="isValid" />是否有效</td>
					<td><input type="checkbox" value="isReturnVist" />是否回访</td>
				</tr>

			</table>
		</form>
	</div>

	



	<!--
		姓名关键字、电话、咨询师、是否缴费、是否有效、
		是否回访、QQ、创建时间/上门时间/首次回访时间/缴费时间/进班时间
	  -->

	<!-- 数据表格tab的工具条 -->
	<div id="tabBar">
		<!-- <a href="javascript:void(0)" class="easyui-linkbutton"
			data-options="iconCls:'icon-add'" onclick="add()">新增</a> -->
		名称:<input type="text" class="easyui-textbox" id="name" />&nbsp;&nbsp;&nbsp;&nbsp;电话：<input
			class="easyui-textbox" type="text" id="phone">&nbsp;&nbsp;&nbsp;&nbsp;
		咨询师：<input class="easyui-textbox" type="text" id="ziXunName">
		&nbsp;&nbsp;&nbsp;&nbsp;QQ：<input type="text" class="easyui-textbox"
			id="qq"> &nbsp;&nbsp;&nbsp;&nbsp;创建时间：<input type="text"
			class="easyui-datebox" id="createTime">
		&nbsp;&nbsp;&nbsp;&nbsp;上门时间：<input type="text" class="easyui-datebox"
			id="homeTime"><br /> 首次回访时间：<input type="text"
			class="easyui-datebox" id="firstVistTime">&nbsp;&nbsp;&nbsp;&nbsp;
		缴费时间：<input type="text" class="easyui-datebox" id="payTime">&nbsp;&nbsp;&nbsp;&nbsp;
		进班时间：<input type="text" class="easyui-datebox" id="inClassTime">
		&nbsp;&nbsp;&nbsp;&nbsp;是否缴费：<select id="isPay"
			class="easyui-combobox" name="是否缴费">
			<option value=" ">---请选择---</option>
			<option value="1">已缴费</option>
			<option value="2">未缴费</option>&nbsp;&nbsp;&nbsp;&nbsp;
		</select> 是否有效：<select id="isValid" class="easyui-combobox" name="是否有效">
			<option value=" ">---请选择---</option>
			<option value="1">有效</option>
			<option value="2">无效</option>&nbsp;&nbsp;&nbsp;&nbsp;
		</select> 是否回访：<select id="isReturnVist" class="easyui-combobox" name="是否回访">
			<option value=" ">---请选择---</option>
			<option value="1">已回访</option>
			<option value="2">未回访</option>
		</select><br /> <a href="javascript:void(0)" class="easyui-linkbutton"
			data-options="iconCls:'icon-edit'" onclick="lookstu()">显示</a> <a
			href="javascript:void(0)" onclick="initStu()"
			class="easyui-linkbutton" data-options="iconCls:'icon-search'">搜索</a>
		<a href="javascript:void(0)" onclick="addStu()"
			class="easyui-linkbutton" data-options="iconCls:'icon-add'">添加</a>
			<!--  <a
			class="easyui-linkbutton" onclick="exportExcel()" id="serach"
			data-options="iconCls:'icon-print'">导出excel</a> -->
			 <a class="easyui-linkbutton" onclick="exportExcel()"
			id="serach" data-options="iconCls:'icon-add'">导出excel</a>
			
	</div>

	<!-- 添加  -->
	<div id="add-dialog" class="easyui-dialog"
		style="width: 600px; height: 300px"
		data-options="title:'新建学员窗口',modal:true,closed:true,
					buttons:[{
						text:'保存',
						handler:function(){bcStu()}
					},{
						text:'关闭',
						handler:function(){clearStu()}
					}]">
		<form>
			<table>
				<thead>
				<!-- <tr>
						<td><label for="name">用户ID:</label></td>
						<td><input class="easyui-validatebox" type="text"
							id="addusersId" /></td>
					</tr> -->
					<tr>
						<td><label for="name">姓名:</label></td>
						<td><input class="easyui-validatebox" type="text"
							id="addname" /></td>
					</tr>

					<tr>
						<td><label for="name">性别:</label></td>
						<td><select id="addsex" class="easyui-combobox">
								<option value="">---请选择---</option>
								<option value="1">男</option>
								<option value="2">女</option>
						</select></td>
					</tr>

					<tr>
						<td><label for="name">年龄:</label></td>
						<td><input class="easyui-validatebox textbox" data-options="validType:'age'" type="text" id="addage" />
						</td>
					</tr>

					<tr>
						<td><label for="name">电话:</label></td>
						<td><input
class="easyui-validatebox textbox" data-options="validType:'phoneRex'" type="text"
							id="addphone" /></td>
					</tr>

					<tr>
						<td><label for="name">学历:</label></td>
						<td><input class="easyui-validatebox" type="text"
							id="addstatus" /></td>
					</tr>

					<tr>
						<td><label for="name">状态:</label></td>
						<td><select id="addstate" class="easyui-combobox">
								<option value=" ">---请选择---</option>
								<option value="2">有状态</option>
								<option value="1">无状态</option>
						</select></td>
					</tr>

					<tr>
						<td><label for="name">来源渠道:</label></td>
						<td><input class="easyui-validatebox" type="text" id="addly" />
						</td>
					</tr>

					<tr>
						<td><label for="name">来源网站:</label></td>
						<td><input class="easyui-validatebox" type="text" id="addwz" />
						</td>
					</tr>

					<tr>
						<td><label for="name">来源关键词:</label></td>
						<td><input class="easyui-validatebox" type="text" id="addgj" />
						</td>
					</tr>

					<tr>
						<td><label for="name">学员QQ:</label></td>
						<td><input 
class="easyui-validatebox textbox" data-options="validType:'qq'" type="text" id="addqq" />
						</td>
					</tr>

					<tr>
						<td><label for="name">微信号:</label></td>
						<td><input class="easyui-validatebox" type="text" id="addwx" />
						</td>
					</tr>

					<tr>
						<td><label for="name">是否报备:</label></td>
						<td><select id="addisBaoBei" class="easyui-combobox">
								<option value=" ">---请选择---</option>
								<option value="1">已报备</option>
								<option value="2">未报备</option>
						</select></td>
					</tr>

					<tr>
						<td><label for="name">在线备注:</label></td>
						<td><input class="easyui-validatebox" type="text" id="addbz" />
						</td>
					</tr>
				</thead>
			</table>
		</form>
	</div>
	<!-- 查看   -->
	<div id="chakan-dialog" class="easyui-dialog"
		style="width: 600px; height: 300px"
		data-options="title:'学员信息窗口',modal:true,closed:true,
					buttons:[{
						text:'关闭',
						handler:function(){closeStu()}
					}]">
		<form id="chakan-frm">
			<table>
				<thead>
					<tr>
						<td><label for="name">创建时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="createTime" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">学员姓名:</label></td>
						<td><input class="easyui-validatebox" type="text" name="name"
							disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">学员电话:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="phone" disabled="disabled" /></td>
					</tr>


					<tr>
						<td><label for="name">性别:</label></td>
						<td><select id="sex" name="sex" class="easyui-combobox"
							disabled="disabled">
								<option value="1">男</option>
								<option value="2">女</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">年龄:</label></td>
						<td><input class="easyui-validatebox" type="text" name="age"
							disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">学历:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="status" disabled="disabled" /></td>
					</tr>
					<!-- <tr>
						<td><label for="name">个人状态:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="state" /></td>
					</tr> -->
					<tr>
						<td><label for="name">状态:</label></td>
						<td><select id="state" name="state" class="easyui-combobox"
							disabled="disabled">
								<option value="2">有状态</option>
								<option value="1">无状态</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">来源渠道:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="msgSource" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">来源网址:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="sourceUrl" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">来源关键词:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="sourceKeyWorld" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">姓名（咨询）:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="ziXunName" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">所在区域:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="address" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">微信:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="weixin" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">学员QQ:</label></td>
						<td><input class="easyui-validatebox" type="text" name="qq"
							disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">来源部门:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="learnForward" disabled="disabled" /></td>
					</tr>

					<tr>
						<td><label for="name">是否报备:</label></td>
						<td><select id="isBaoBei" class="easyui-combobox"
							disabled="disabled">
								<option value="1">已报备</option>
								<option value="2">未报备</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">课程方向:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="record" disabled="disabled" /></td>
					</tr>

					<tr>
						<td><label for="name">是否有效:</label></td>
						<td><select id="isValid" name="isValid"
							class="easyui-combobox" disabled="disabled">
								<option value="1">有效</option>
								<option value="2">无效</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">打分:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="dafen" disabled="disabled" /></td>
					</tr>

					<tr>
						<td><label for="name">是否回访:</label></td>
						<td><select id="isReturnVist" name="isReturnVist"
							class="easyui-combobox" disabled="disabled">
								<option value="1">已回访</option>
								<option value="2">未回访</option>
						</select></td>
					</tr>



					<tr>
						<td><label for="name">首次回访时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="firstVistTime" disabled="disabled" /></td>
					</tr>

					<tr>
						<td><label for="name">是否上门:</label></td>
						<td><select id="isHome" name="isHome" class="easyui-combobox"
							disabled="disabled">
								<option value="1">已上门</option>
								<option value="2">未上门</option>
						</select></td>
					</tr>
					<tr>
						<td><label for="name">上门时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="homeTime" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">无效原因:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="lostValid" disabled="disabled" /></td>
					</tr>
					<!-- <tr>
						<td><label for="name">是否缴费:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="isPay" /></td>
					</tr> -->
					<tr>
						<td><label for="name">是否缴费:</label></td>
						<td><select id="isPay" name="isPay" class="easyui-combobox"
							disabled="disabled">
								<option value="1">已缴费</option>
								<option value="2">未缴费</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">缴费时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="payTime" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">金额:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="money" disabled="disabled" /></td>
					</tr>
					<!-- <tr>
						<td><label for="name">是否退费:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="isReturnMoney" /></td>
					</tr> -->

					<tr>
						<td><label for="name">是否退费:</label></td>
						<td><select id="isReturnMoney" name="isReturnMoney"
							class="easyui-combobox" disabled="disabled">
								<option value="1">已退费</option>
								<option value="2">未退费</option>
						</select></td>
					</tr>

					<!-- <tr>
						<td><label for="name">是否进班:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="isInClass" /></td>
					</tr> -->

					<tr>
						<td><label for="name">是否进班:</label></td>
						<td><select id="isInClass" name="isInClass"
							class="easyui-combobox" disabled="disabled">
								<option value="1">已进班</option>
								<option value="2">未进班</option>
						</select></td>
					</tr>



					<tr>
						<td><label for="name">进班时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="inClassTime" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">进班备注:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="inClassContent" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">退费原因:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="askerContent" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">定金金额:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="preMoney" disabled="disabled" /></td>
					</tr>
					<tr>
						<td><label for="name">定金时间:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="preMoneyTime" disabled="disabled" /></td>
					</tr>
				</thead>
			</table>
		</form>
	</div>

	<!-- 修改 -->
	<div id="edit-dialog" class="easyui-dialog"
		style="width: 600px; height: 300px"
		data-options="title:'我的对话框',modal:true,closed:true,
					buttons:[{
						text:'保存',
						handler:function(){updateStu()}
					},{
						text:'关闭',
						handler:function(){updateClear()}
					}]">
		<form id="edit-frm">
			<table>
				<thead>
					<tr>
						<td><label for="name">编号:</label></td>
						<td><input class="easyui-validatebox" type="text" name="id"
							id="updateid" /></td>
					</tr>
					<tr>
						<td><label for="name">姓名:</label></td>
						<td><input class="easyui-validatebox" type="text" name="name"
							id="updatename" /></td>
					</tr>


					<tr>
						<td><label for="name">性别:</label></td>
						<td><select id="updatesex" name="updatesex"
							class="easyui-combobox">
								<option value="1">男</option>
								<option value="2">女</option>
						</select></td>
					</tr>


					<tr>
						<td><label for="name">年龄:</label></td>
						<td><input 
class="easyui-validatebox textbox" data-options="validType:'age'" type="text" name="age"
							id="updateage" /></td>
					</tr>
					<tr>
						<td><label for="name">电话:</label></td>
						<td><input
class="easyui-validatebox textbox" data-options="validType:'phoneRex'" type="text"
							name="phone" id="updatephone" /></td>
					</tr>
					<tr>
						<td><label for="name">学历:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="status" id="updatestatus" /></td>
					</tr>

					<tr>
						<td><label for="name">状态:</label></td>
						<td><select id="updatestate" name="updatesex"
							class="easyui-combobox">
								<option value="1">有状态</option>
								<option value="2">无状态</option>
						</select></td>
					</tr>
					<!--  <tr>
							<td>
								<label for="name">性别:</label>
							</td>
							<td>
								<select id="updatesex"  name="updatesex" class="easyui-combobox">   
								    <option value="1">男</option>   
								    <option value="2">女</option>   
								</select>
							</td>
						</tr> -->


					<tr>
						<td><label for="name">来源渠道:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="msgSource" id="updatemsgSource" /></td>
					</tr>
					<tr>
						<td><label for="name">来源网站:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="sourceUrl" id="updatesourceUrl" /></td>
					</tr>
					<tr>
						<td><label for="name">来源关键词:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="sourceKeyWorld" id="updatesourceKeyWorld" /></td>
					</tr>
					<tr>
						<td><label for="name">所在区域:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="address" id="updateaddress" /></td>
					</tr>
					<tr>
						<td><label for="name">学员关注:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="concern" id="updateconcern" /></td>
					</tr>
					<tr>
						<td><label for="name">来源部门:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="learnForward" id="updatelearnForward" /></td>
					</tr>
					<tr>
						<td><label for="name">学员QQ:</label></td>
						<td><input 
class="easyui-validatebox textbox" data-options="validType:'qq'" type="text" name="qq"
							id="updateqq" /></td>
					</tr>
					<tr>
						<td><label for="name">微信号:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="weixin" id="updateweixin" /></td>
					</tr>

					<tr>
						<td><label for="name">是否报备:</label></td>
						<td><select id="updateisBaoBei" name="updateisBaoBei"
							class="easyui-combobox">
								<option value="1">已报备</option>
								<option value="2">未报备</option>
						</select></td>
					</tr>

					<tr>
						<td><label for="name">咨询师:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="ziXunName" id="updateziXunName" /></td>
					</tr>
					<tr>
						<td><label for="name">录入人:</label></td>
						<td><input class="easyui-validatebox" type="text"
							name="createUser" id="updatecreateUser" /></td>
					</tr>

				</thead>
			</table>
		</form>
	</div>


<%-- 导出EXCel窗口 --%>
	<div id="win-daochu" class="easyui-window"
		data-options="iconCls:'icon-save',closed:true,width:600,height:380,modal:true"
		title="导出Excel">
		 <table id="tab-daochu" cellpadding="10" >
			<tr>														
				<td>
					<label for="content">填写表名:</label>
               		<input class="easyui-textbox" type="text" id="daochu-title" style="width:200px">
				</td>
			</tr>
			<tr>														
				<td>
					<h3>选列:选择要显示的列</h3>
					<table id="daochu-checkbox" style="border:1px solid #000000;" cellpadding="15">
						<tr>
							<td><input type="checkbox" name="id" value="ID" checked="checked"/>ID</td>
							<td><input type="checkbox" name="name" value="姓名" checked="checked"/>姓名</td>
							<td><input type="checkbox" name="sex" value="性别" checked="checked"/>年龄</td>
							<td><input type="checkbox" name="age" value="年龄" checked="checked"/>性别</td>
							<td><input type="checkbox" name="phone" value="电话" checked="checked" />咨询师姓名</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="status" value="学历" checked="checked"/>电话</td>
							<td><input type="checkbox" name="state" value="状态" checked="checked"/>学历</td>
							<td><input type="checkbox" name="dafen" value="打分" checked="checked"/>状态</td>
							<td><input type="checkbox" name="msgSource" value="来源渠道" checked="checked"/>来源渠道</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="sourceUrl" value="来源网站" checked="checked"/>来源网站</td>
							<td><input type="checkbox" name="sourceKeyWorld" value="来源关键词" checked="checked"/>来源关键词</td>
							<td><input type="checkbox" name="address" value="地址" checked="checked"/>地址</td>
							<td><input type="checkbox" name="netPusherId" value="推销者" checked="checked"/>推销者</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="askerId" value="发布者Id" checked="checked"/>发布者Id</td>
							<td><input type="checkbox" name="qq" value="qq" checked="checked"/>QQ</td>
							<td><input type="checkbox" name="weixin" value="微信" checked="checked"/>微信</td>
							<td><input type="checkbox" name="content" value="内容" checked="checked"/>内容</td>
						</tr>
							<tr>
							 <td><input type="checkbox" name="createTime" value="创建时间" checked="checked"/>创建时间</td>
							<td><input type="checkbox" name="learnForward" value="来源部门" checked="checked"/>来源部门</td>
							<td><input type="checkbox" name="record" value="课程方向" checked="checked"/>课程方向</td>
							<td><input type="checkbox" name="firstVistTime" value="第一次回访时间" checked="checked"/>第一次回访时间</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="isHome" value="是否上门" checked="checked"/>是否上门</td>
							<td><input type="checkbox" name="homeTime" value="上门时间" checked="checked"/>上门时间</td>
							<td><input type="checkbox" name="lostValid" value="无效原因" checked="checked"/>无效原因</td>
							<td><input type="checkbox" name="payTime" value="缴费时间" checked="checked"/>缴费时间</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="money" value="金额" checked="checked"/>金额</td>
							<td><input type="checkbox" name="isReturnMoney" value="是否退费" checked="checked"/>是否退费</td>
							<td><input type="checkbox" name="isInClass" value="是否进班" checked="checked"/>是否进班</td>
							<td><input type="checkbox" name="inClassTime" value="进班时间" checked="checked"/>进班时间</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="inClassContent" value="进班备注" checked="checked"/>进班备注</td>
							<td><input type="checkbox" name="askerContent" value="退费原因" checked="checked"/>退费原因</td>
							 <td><input type="checkbox" name="isDel" value="是否删除" checked="checked"/>是否删除</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="formPart" value="来源部门" checked="checked"/>来源部门</td>
							<td><input type="checkbox" name="concern" value="学员关注" checked="checked"/>学员关注</td>
							<td><input type="checkbox" name="isBaoBei" value="是否报备" checked="checked"/>是否报备</td>
							<td><input type="checkbox" name="ziXunName" value="咨询师姓名" checked="checked"/>咨询师姓名</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="createUser" value="录入人" checked="checked"/>录入人</td>
							<td><input type="checkbox" name="returnMoneyReason" value="退费原因" checked="checked"/>退费原因</td>
							<td><input type="checkbox" name="preMoney" value="定金金额" checked="checked"/>定金金额</td>
							<td><input type="checkbox" name="preMoneyTime" value="定金时间" checked="checked"/>定金时间</td>
						</tr>
						<tr>
							<td><input type="checkbox" name="isPay" value="是否缴费" checked="checked"/>是否缴费</td>
							<td><input type="checkbox" name="isValid" value="是否有效" checked="checked"/>是否有效</td>
							<td><input type="checkbox" name="isReturnVist" value="是否回访" checked="checked"/>是否回访</td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>														
				<td>
				<a href="javascript:void(0)" class="easyui-linkbutton" onclick="bgdaochu()" data-options="iconCls:'icon-print'">确认导出Excel</a>    
				</td>
			</tr>
		</table> 
	</div> 










</body>
</html>